<?php

    require_once dirname(dirname(__FILE__)) . '/config/config.php';
    require_once DOCUMENT_ROOT . DIR_SHARED_CONFIG . 'connection.php';


    class dao_industry
    {

        //Methods
        public function __construct()
        {

        }

        public function get_all()
        {
            $db  = new connection();
            $con = $db->open_connect();

            $query = "SELECT * "
                . "FROM tbl_industry ";
            $result = mysqli_query($con, $query)
            or die("Query fail: " . mysqli_error());

            $list = array();
            while ($row = mysqli_fetch_array($result)) {
                array_push($list, $row);
            }
            $db->close_connect();

            return $list;
        }

        public function get_by_id($id)
        {
            $db  = new connection();
            $con = $db->open_connect();

            $query = "SELECT * "
                . "FROM tbl_industry "
                . "WHERE id = " . $id;
            $result = mysqli_query($con, $query) or die("Query fail: " . mysqli_error());

            $row = mysqli_fetch_array($result);

            $db->close_connect();

            return $row;
        }

        public function delete($id)
        {
            $db  = new connection();
            $con = $db->open_connect();

            $query = "DELETE FROM tbl_industry WHERE id = " . $id;
            mysqli_query($con, $query) or die("Query fail: " . mysqli_error());

            $db->close_connect();

            return TRUE;
        }

        public function check_exist($id, $name)
        {
            $db  = new connection();
            $con = $db->open_connect();

            $query = "SELECT * FROM tbl_industry WHERE id != $id AND name = '$name'";
            $result = mysqli_query($con, $query) or die("Query fail: " . mysqli_error());
            $row = mysqli_fetch_array($result);

            if ($row != NULL) {
                $db->close_connect();

                return TRUE;
            } else {
                $db->close_connect();

                return FALSE;
            }
        }

        public function  save($id, $name)
        {
            $db  = new connection();
            $con = $db->open_connect();

            if ($this->check_exist($id, $name)) {
                return FALSE;
            } else if ($id == 0) {
                $query = "INSERT INTO tbl_industry(name) VALUES ('$name')";
            } else {
                $query = "UPDATE tbl_industry SET name = '$name' WHERE id = $id";
            }

            mysqli_query($con, $query) or die("Query fail: " . mysqli_error());

            $db->close_connect();

            return TRUE;
        }

    }
